Pandas Profiling Report

Dataset statistics

Number of variables	16
Number of observations	20000
Missing cells	8261
Missing cells (%)	2.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.4 MiB
Average record size in memory	128.0 B

Variable types

Numeric	10
Text	3
Categorical	2
DateTime	1

Alerts

`last_review` has 4123 (20.6%) missing values	Missing
`reviews_per_month` has 4123 (20.6%) missing values	Missing
`minimum_nights` is highly skewed (γ1 = 25.17996962)	Skewed
`id` has unique values	Unique
`number_of_reviews` has 4123 (20.6%) zeros	Zeros
`availability_365` has 7176 (35.9%) zeros	Zeros

Reproduction

Analysis started	2024-11-23 02:50:40.741828
Analysis finished	2024-11-23 02:51:05.710282
Duration	24.97 seconds
Software version	ydata-profiling vv4.12.0
Download configuration	config.json

id
Real number (ℝ)

Unique

Distinct	20000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18923801

Minimum	2539
Maximum	36485609
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	156.4 KiB

Quantile statistics

Minimum	2539
5-th percentile	1193873.9
Q1	9393540.5
median	19521168
Q3	29129359
95-th percentile	35275607
Maximum	36485609
Range	36483070
Interquartile range (IQR)	19735818

Descriptive statistics

Standard deviation	11012232
Coefficient of variation (CV)	0.58192498
Kurtosis	-1.233323
Mean	18923801
Median Absolute Deviation (MAD)	9896304
Skewness	-0.075380527
Sum	3.7847602 × 10¹¹
Variance	1.2126926 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9138664	1	< 0.1%
13746962	1	< 0.1%
449130	1	< 0.1%
7885044	1	< 0.1%
31315168	1	< 0.1%
16341416	1	< 0.1%
16133101	1	< 0.1%
17922181	1	< 0.1%
28972637	1	< 0.1%
20917712	1	< 0.1%
Other values (19990)	19990	> 99.9%

Value	Count	Frequency (%)
2539	1	< 0.1%
3831	1	< 0.1%
5022	1	< 0.1%
5121	1	< 0.1%
5203	1	< 0.1%
5238	1	< 0.1%
5803	1	< 0.1%
6090	1	< 0.1%
6848	1	< 0.1%
7750	1	< 0.1%

Value	Count	Frequency (%)
36485609	1	< 0.1%
36485057	1	< 0.1%
36480292	1	< 0.1%
36479723	1	< 0.1%
36478343	1	< 0.1%
36472171	1	< 0.1%
36471896	1	< 0.1%
36468880	1	< 0.1%
36458668	1	< 0.1%
36456829	1	< 0.1%

name
Text

Distinct	19768
Distinct (%)	98.9%
Missing	7
Missing (%)	< 0.1%
Memory size	156.4 KiB

Length

Max length	179
Median length	68
Mean length	36.902466
Min length	1

Characters and Unicode

Total characters	737791
Distinct characters	511
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	19599 ?
Unique (%)	98.0%

Sample

1st row	Private Lg Room 15 min to Manhattan
2nd row	TIME SQUARE CHARMING ONE BED IN HELL'S KITCHEN,NYC
3rd row	Voted #1 Location Quintessential 1BR W Village Apt
4th row	Spacious 1 bedroom apartment 15min from Manhattan
5th row	Big beautiful bedroom in huge Bushwick apartment

Value	Count	Frequency (%)
in	6813	5.6%
room	4038	3.3%
	3388	2.8%
bedroom	3145	2.6%
private	2935	2.4%
apartment	2748	2.2%
cozy	2034	1.7%
apt	1843	1.5%
brooklyn	1666	1.4%
the	1620	1.3%
Other values (7025)	91941	75.3%

Most occurring characters

Value	Count	Frequency (%)
	102878	13.9%
e	50869	6.9%
o	50103	6.8%
t	42994	5.8%
a	42392	5.7%
r	40165	5.4%
i	38708	5.2%
n	38494	5.2%
l	21159	2.9%
m	20160	2.7%
Other values (501)	289869	39.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	737791	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	102878	13.9%
e	50869	6.9%
o	50103	6.8%
t	42994	5.8%
a	42392	5.7%
r	40165	5.4%
i	38708	5.2%
n	38494	5.2%
l	21159	2.9%
m	20160	2.7%
Other values (501)	289869	39.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	737791	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	102878	13.9%
e	50869	6.9%
o	50103	6.8%
t	42994	5.8%
a	42392	5.7%
r	40165	5.4%
i	38708	5.2%
n	38494	5.2%
l	21159	2.9%
m	20160	2.7%
Other values (501)	289869	39.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	737791	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	102878	13.9%
e	50869	6.9%
o	50103	6.8%
t	42994	5.8%
a	42392	5.7%
r	40165	5.4%
i	38708	5.2%
n	38494	5.2%
l	21159	2.9%
m	20160	2.7%
Other values (501)	289869	39.3%

host_id
Real number (ℝ)

Distinct	17027
Distinct (%)	85.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	67460344

Minimum	2571
Maximum	2.7427328 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	156.4 KiB

Quantile statistics

Minimum	2571
5-th percentile	779450
Q1	7853718.2
median	31114310
Q3	1.0684256 × 10⁸
95-th percentile	2.4209584 × 10⁸
Maximum	2.7427328 × 10⁸
Range	2.7427071 × 10⁸
Interquartile range (IQR)	98988842

Descriptive statistics

Standard deviation	78579365
Coefficient of variation (CV)	1.1648231
Kurtosis	0.20879863
Mean	67460344
Median Absolute Deviation (MAD)	27863860
Skewness	1.219649
Sum	1.3492069 × 10¹²
Variance	6.1747166 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
219517861	131	0.7%
107434423	89	0.4%
30283594	53	0.3%
12243051	37	0.2%
16098958	36	0.2%
137358866	36	0.2%
61391963	34	0.2%
22541573	32	0.2%
200380610	27	0.1%
26377263	24	0.1%
Other values (17017)	19501	97.5%

Value	Count	Frequency (%)
2571	1	< 0.1%
2787	3	< 0.1%
3151	1	< 0.1%
3415	1	< 0.1%
3563	1	< 0.1%
3647	2	< 0.1%
4396	1	< 0.1%
4869	1	< 0.1%
5089	1	< 0.1%
6041	1	< 0.1%

Value	Count	Frequency (%)
274273284	1	< 0.1%
274195458	1	< 0.1%
274103383	1	< 0.1%
274079964	1	< 0.1%
273870123	1	< 0.1%
273841667	1	< 0.1%
273812306	1	< 0.1%
273741577	1	< 0.1%
273656890	1	< 0.1%
273632292	1	< 0.1%

host_name
Text

Distinct	6517
Distinct (%)	32.6%
Missing	8
Missing (%)	< 0.1%
Memory size	156.4 KiB

Length

Max length	35
Median length	31
Mean length	6.112445
Min length	1

Characters and Unicode

Total characters	122200
Distinct characters	140
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4203 ?
Unique (%)	21.0%

Sample

1st row	Iris
2nd row	Johlex
3rd row	John
4th row	Regan
5th row	Megan

Value	Count	Frequency (%)
	428	1.9%
and	250	1.1%
david	185	0.8%
michael	183	0.8%
sonder	168	0.8%
john	148	0.7%
nyc	137	0.6%
alex	129	0.6%
laura	121	0.5%
maria	109	0.5%
Other values (6048)	20426	91.7%

Most occurring characters

Value	Count	Frequency (%)
a	15469	12.7%
e	11787	9.6%
i	9892	8.1%
n	9892	8.1%
r	7360	6.0%
l	6239	5.1%
o	5194	4.3%
t	3817	3.1%
s	3737	3.1%
h	3686	3.0%
Other values (130)	45127	36.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	122200	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	15469	12.7%
e	11787	9.6%
i	9892	8.1%
n	9892	8.1%
r	7360	6.0%
l	6239	5.1%
o	5194	4.3%
t	3817	3.1%
s	3737	3.1%
h	3686	3.0%
Other values (130)	45127	36.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	122200	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	15469	12.7%
e	11787	9.6%
i	9892	8.1%
n	9892	8.1%
r	7360	6.0%
l	6239	5.1%
o	5194	4.3%
t	3817	3.1%
s	3737	3.1%
h	3686	3.0%
Other values (130)	45127	36.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	122200	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	15469	12.7%
e	11787	9.6%
i	9892	8.1%
n	9892	8.1%
r	7360	6.0%
l	6239	5.1%
o	5194	4.3%
t	3817	3.1%
s	3737	3.1%
h	3686	3.0%
Other values (130)	45127	36.9%

neighbourhood_group
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.4 KiB

Manhattan	8774
Brooklyn	8265
Queens	2355
Bronx	441
Staten Island	165

Length

Max length	13
Median length	9
Mean length	8.1783
Min length	5

Characters and Unicode

Total characters	163566
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Queens
2nd row	Manhattan
3rd row	Manhattan
4th row	Queens
5th row	Brooklyn

Common Values

Value	Count	Frequency (%)
Manhattan	8774	43.9%
Brooklyn	8265	41.3%
Queens	2355	11.8%
Bronx	441	2.2%
Staten Island	165	0.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
manhattan	8774	43.5%
brooklyn	8265	41.0%
queens	2355	11.7%
bronx	441	2.2%
staten	165	0.8%
island	165	0.8%

Most occurring characters

Value	Count	Frequency (%)
n	28939	17.7%
a	26652	16.3%
t	17878	10.9%
o	16971	10.4%
M	8774	5.4%
h	8774	5.4%
B	8706	5.3%
r	8706	5.3%
l	8430	5.2%
y	8265	5.1%
Other values (10)	21471	13.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	163566	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	28939	17.7%
a	26652	16.3%
t	17878	10.9%
o	16971	10.4%
M	8774	5.4%
h	8774	5.4%
B	8706	5.3%
r	8706	5.3%
l	8430	5.2%
y	8265	5.1%
Other values (10)	21471	13.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	163566	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	28939	17.7%
a	26652	16.3%
t	17878	10.9%
o	16971	10.4%
M	8774	5.4%
h	8774	5.4%
B	8706	5.3%
r	8706	5.3%
l	8430	5.2%
y	8265	5.1%
Other values (10)	21471	13.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	163566	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	28939	17.7%
a	26652	16.3%
t	17878	10.9%
o	16971	10.4%
M	8774	5.4%
h	8774	5.4%
B	8706	5.3%
r	8706	5.3%
l	8430	5.2%
y	8265	5.1%
Other values (10)	21471	13.1%

neighbourhood
Text

Distinct	217
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	156.4 KiB

Length

Max length	26
Median length	17
Mean length	11.8819
Min length	4

Characters and Unicode

Total characters	237638
Distinct characters	54
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	20 ?
Unique (%)	0.1%

Sample

1st row	Sunnyside
2nd row	Hell's Kitchen
3rd row	West Village
4th row	Astoria
5th row	Bushwick

Value	Count	Frequency (%)
east	2690	8.3%
side	1872	5.8%
williamsburg	1580	4.9%
harlem	1579	4.9%
upper	1504	4.7%
bedford-stuyvesant	1503	4.6%
heights	1462	4.5%
village	1301	4.0%
west	1142	3.5%
bushwick	987	3.1%
Other values (229)	16713	51.7%

Most occurring characters

Value	Count	Frequency (%)
e	21824	9.2%
i	17188	7.2%
s	16285	6.9%
t	15839	6.7%
a	15504	6.5%
l	14091	5.9%
r	13837	5.8%
	12333	5.2%
n	10687	4.5%
o	9832	4.1%
Other values (44)	90218	38.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	237638	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	21824	9.2%
i	17188	7.2%
s	16285	6.9%
t	15839	6.7%
a	15504	6.5%
l	14091	5.9%
r	13837	5.8%
	12333	5.2%
n	10687	4.5%
o	9832	4.1%
Other values (44)	90218	38.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	237638	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	21824	9.2%
i	17188	7.2%
s	16285	6.9%
t	15839	6.7%
a	15504	6.5%
l	14091	5.9%
r	13837	5.8%
	12333	5.2%
n	10687	4.5%
o	9832	4.1%
Other values (44)	90218	38.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	237638	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	21824	9.2%
i	17188	7.2%
s	16285	6.9%
t	15839	6.7%
a	15504	6.5%
l	14091	5.9%
r	13837	5.8%
	12333	5.2%
n	10687	4.5%
o	9832	4.1%
Other values (44)	90218	38.0%

latitude
Real number (ℝ)

Distinct	12439
Distinct (%)	62.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	40.728455

Minimum	40.50873
Maximum	40.91306
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	156.4 KiB

Quantile statistics

Minimum	40.50873
5-th percentile	40.64513
Q1	40.68942
median	40.72273
Q3	40.76299
95-th percentile	40.825653
Maximum	40.91306
Range	0.40433
Interquartile range (IQR)	0.07357

Descriptive statistics

Standard deviation	0.054755077
Coefficient of variation (CV)	0.0013443937
Kurtosis	0.10856551
Mean	40.728455
Median Absolute Deviation (MAD)	0.03658
Skewness	0.23016938
Sum	814569.1
Variance	0.0029981185
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40.71813	8	< 0.1%
40.69414	8	< 0.1%
40.68634	8	< 0.1%
40.72232	8	< 0.1%
40.68683	7	< 0.1%
40.71801	7	< 0.1%
40.68084	7	< 0.1%
40.70587	7	< 0.1%
40.72607	7	< 0.1%
40.6898	6	< 0.1%
Other values (12429)	19927	99.6%

Value	Count	Frequency (%)
40.50873	1	< 0.1%
40.52293	1	< 0.1%
40.53076	1	< 0.1%
40.53871	1	< 0.1%
40.53884	1	< 0.1%
40.53939	1	< 0.1%
40.54106	1	< 0.1%
40.54312	1	< 0.1%
40.5455	1	< 0.1%
40.54857	1	< 0.1%

Value	Count	Frequency (%)
40.91306	1	< 0.1%
40.90527	1	< 0.1%
40.90391	1	< 0.1%
40.90356	1	< 0.1%
40.90329	1	< 0.1%
40.90281	1	< 0.1%
40.9026	1	< 0.1%
40.89981	1	< 0.1%
40.89811	1	< 0.1%
40.89756	1	< 0.1%

longitude
Real number (ℝ)

Distinct	10181
Distinct (%)	50.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-73.952125

Minimum	-74.23914
Maximum	-73.71795
Zeros	0
Zeros (%)	0.0%
Negative	20000
Negative (%)	100.0%
Memory size	156.4 KiB

Quantile statistics

Minimum	-74.23914
5-th percentile	-74.004181
Q1	-73.98303
median	-73.95564
Q3	-73.93638
95-th percentile	-73.864896
Maximum	-73.71795
Range	0.52119
Interquartile range (IQR)	0.04665

Descriptive statistics

Standard deviation	0.046558783
Coefficient of variation (CV)	-0.00062958006
Kurtosis	4.9382429
Mean	-73.952125
Median Absolute Deviation (MAD)	0.024895
Skewness	1.2551004
Sum	-1479042.5
Variance	0.0021677203
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-73.98589	10	0.1%
-73.95742	9	< 0.1%
-73.94829	9	< 0.1%
-73.95121	9	< 0.1%
-73.95427	9	< 0.1%
-73.95725	9	< 0.1%
-73.98043	9	< 0.1%
-73.95677	8	< 0.1%
-73.98874	8	< 0.1%
-73.98985	8	< 0.1%
Other values (10171)	19912	99.6%

Value	Count	Frequency (%)
-74.23914	1	< 0.1%
-74.21238	1	< 0.1%
-74.20295	1	< 0.1%
-74.19826	1	< 0.1%
-74.19626	1	< 0.1%
-74.18259	1	< 0.1%
-74.17628	1	< 0.1%
-74.17388	1	< 0.1%
-74.17117	1	< 0.1%
-74.17065	1	< 0.1%

Value	Count	Frequency (%)
-73.71795	1	< 0.1%
-73.71829	1	< 0.1%
-73.72582	1	< 0.1%
-73.72716	1	< 0.1%
-73.72731	1	< 0.1%
-73.7274	1	< 0.1%
-73.72778	1	< 0.1%
-73.72817	1	< 0.1%
-73.72901	1	< 0.1%
-73.72928	1	< 0.1%

room_type
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.4 KiB

Entire home/apt	10384
Private room	9172
Shared room	444

Length

Max length	15
Median length	15
Mean length	13.5354
Min length	11

Characters and Unicode

Total characters	270708
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Private room
2nd row	Entire home/apt
3rd row	Entire home/apt
4th row	Entire home/apt
5th row	Private room

Common Values

Value	Count	Frequency (%)
Entire home/apt	10384	51.9%
Private room	9172	45.9%
Shared room	444	2.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
entire	10384	26.0%
home/apt	10384	26.0%
room	9616	24.0%
private	9172	22.9%
shared	444	1.1%

Most occurring characters

Value	Count	Frequency (%)
e	30384	11.2%
t	29940	11.1%
o	29616	10.9%
r	29616	10.9%
a	20000	7.4%
	20000	7.4%
m	20000	7.4%
i	19556	7.2%
h	10828	4.0%
p	10384	3.8%
Other values (7)	50384	18.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	270708	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	30384	11.2%
t	29940	11.1%
o	29616	10.9%
r	29616	10.9%
a	20000	7.4%
	20000	7.4%
m	20000	7.4%
i	19556	7.2%
h	10828	4.0%
p	10384	3.8%
Other values (7)	50384	18.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	270708	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	30384	11.2%
t	29940	11.1%
o	29616	10.9%
r	29616	10.9%
a	20000	7.4%
	20000	7.4%
m	20000	7.4%
i	19556	7.2%
h	10828	4.0%
p	10384	3.8%
Other values (7)	50384	18.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	270708	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	30384	11.2%
t	29940	11.1%
o	29616	10.9%
r	29616	10.9%
a	20000	7.4%
	20000	7.4%
m	20000	7.4%
i	19556	7.2%
h	10828	4.0%
p	10384	3.8%
Other values (7)	50384	18.6%

price
Real number (ℝ)

Distinct	544
Distinct (%)	2.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	153.26905

Minimum	0
Maximum	10000
Zeros	5
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	156.4 KiB

Quantile statistics

Minimum	0
5-th percentile	40
Q1	69
median	105
Q3	175
95-th percentile	350
Maximum	10000
Range	10000
Interquartile range (IQR)	106

Descriptive statistics

Standard deviation	243.32561
Coefficient of variation (CV)	1.5875717
Kurtosis	538.29758
Mean	153.26905
Median Absolute Deviation (MAD)	45
Skewness	18.30469
Sum	3065381
Variance	59207.352
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	856	4.3%
150	821	4.1%
50	636	3.2%
200	590	2.9%
75	570	2.9%
60	555	2.8%
80	531	2.7%
70	482	2.4%
65	471	2.4%
120	471	2.4%
Other values (534)	14017	70.1%

Value	Count	Frequency (%)
0	5	< 0.1%
10	6	< 0.1%
11	2	< 0.1%
12	1	< 0.1%
13	1	< 0.1%
15	1	< 0.1%
16	3	< 0.1%
18	1	< 0.1%
19	3	< 0.1%
20	13	0.1%

Value	Count	Frequency (%)
10000	1	< 0.1%
9999	1	< 0.1%
8500	1	< 0.1%
7703	1	< 0.1%
7500	1	< 0.1%
6500	2	< 0.1%
5250	1	< 0.1%
5100	1	< 0.1%
5000	1	< 0.1%
4500	2	< 0.1%

minimum_nights
Real number (ℝ)

Skewed

Distinct	75
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.9921

Minimum	1
Maximum	1250
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	156.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	5
95-th percentile	30
Maximum	1250
Range	1249
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	21.645449
Coefficient of variation (CV)	3.0957007
Kurtosis	1072.1676
Mean	6.9921
Median Absolute Deviation (MAD)	1
Skewness	25.17997
Sum	139842
Variance	468.52546
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	5248	26.2%
2	4796	24.0%
3	3309	16.5%
30	1540	7.7%
4	1328	6.6%
5	1208	6.0%
7	855	4.3%
6	307	1.5%
14	217	1.1%
10	183	0.9%
Other values (65)	1009	5.0%

Value	Count	Frequency (%)
1	5248	26.2%
2	4796	24.0%
3	3309	16.5%
4	1328	6.6%
5	1208	6.0%
6	307	1.5%
7	855	4.3%
8	52	0.3%
9	34	0.2%
10	183	0.9%

Value	Count	Frequency (%)
1250	1	< 0.1%
999	2	< 0.1%
480	1	< 0.1%
400	1	< 0.1%
370	1	< 0.1%
365	14	0.1%
364	1	< 0.1%
300	1	< 0.1%
299	1	< 0.1%
240	2	< 0.1%

number_of_reviews
Real number (ℝ)

Zeros

Distinct	323
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23.2741

Minimum	0
Maximum	607
Zeros	4123
Zeros (%)	20.6%
Negative	0
Negative (%)	0.0%
Memory size	156.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	5
Q3	23
95-th percentile	114
Maximum	607
Range	607
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	44.927793
Coefficient of variation (CV)	1.9303772
Kurtosis	20.229807
Mean	23.2741
Median Absolute Deviation (MAD)	5
Skewness	3.7613755
Sum	465482
Variance	2018.5066
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4123	20.6%
1	2131	10.7%
2	1394	7.0%
3	1033	5.2%
4	827	4.1%
5	631	3.2%
6	560	2.8%
7	513	2.6%
8	469	2.3%
9	400	2.0%
Other values (313)	7919	39.6%

Value	Count	Frequency (%)
0	4123	20.6%
1	2131	10.7%
2	1394	7.0%
3	1033	5.2%
4	827	4.1%
5	631	3.2%
6	560	2.8%
7	513	2.6%
8	469	2.3%
9	400	2.0%

Value	Count	Frequency (%)
607	1	< 0.1%
594	1	< 0.1%
510	1	< 0.1%
488	1	< 0.1%
474	1	< 0.1%
467	1	< 0.1%
466	1	< 0.1%
459	1	< 0.1%
448	1	< 0.1%
447	1	< 0.1%

last_review
Date

Missing

Distinct	1507
Distinct (%)	9.5%
Missing	4123
Missing (%)	20.6%
Memory size	156.4 KiB

Minimum	2011-05-12 00:00:00
Maximum	2019-07-08 00:00:00

Histogram with fixed size bins (bins=50)

reviews_per_month
Real number (ℝ)

Missing

Distinct	790
Distinct (%)	5.0%
Missing	4123
Missing (%)	20.6%
Infinite	0
Infinite (%)	0.0%
Mean	1.377446

Minimum	0.01
Maximum	27.95
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	156.4 KiB

Quantile statistics

Minimum	0.01
5-th percentile	0.04
Q1	0.19
median	0.72
Q3	2.01
95-th percentile	4.67
Maximum	27.95
Range	27.94
Interquartile range (IQR)	1.82

Descriptive statistics

Standard deviation	1.6830056
Coefficient of variation (CV)	1.2218306
Kurtosis	11.9517
Mean	1.377446
Median Absolute Deviation (MAD)	0.62
Skewness	2.4357993
Sum	21869.71
Variance	2.8325079
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	378	1.9%
0.02	378	1.9%
0.05	352	1.8%
0.03	334	1.7%
0.04	274	1.4%
0.08	263	1.3%
0.16	255	1.3%
0.09	246	1.2%
0.06	234	1.2%
0.11	222	1.1%
Other values (780)	12941	64.7%
(Missing)	4123	20.6%

Value	Count	Frequency (%)
0.01	18	0.1%
0.02	378	1.9%
0.03	334	1.7%
0.04	274	1.4%
0.05	352	1.8%
0.06	234	1.2%
0.07	172	0.9%
0.08	263	1.3%
0.09	246	1.2%
0.1	198	1.0%

Value	Count	Frequency (%)
27.95	1	< 0.1%
20.94	1	< 0.1%
19.75	1	< 0.1%
17.82	1	< 0.1%
16.22	1	< 0.1%
14	1	< 0.1%
13.45	1	< 0.1%
13.42	1	< 0.1%
13.24	1	< 0.1%
13.15	1	< 0.1%

calculated_host_listings_count
Real number (ℝ)

Distinct	47
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.95545

Minimum	1
Maximum	327
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	156.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	14
Maximum	327
Range	326
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	32.433831
Coefficient of variation (CV)	4.6630815
Kurtosis	70.365352
Mean	6.95545
Median Absolute Deviation (MAD)	0
Skewness	8.0961239
Sum	139109
Variance	1051.9534
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
1	13290	66.5%
2	2688	13.4%
3	1174	5.9%
4	570	2.9%
5	361	1.8%
6	226	1.1%
8	168	0.8%
7	166	0.8%
327	131	0.7%
9	103	0.5%
Other values (37)	1123	5.6%

Value	Count	Frequency (%)
1	13290	66.5%
2	2688	13.4%
3	1174	5.9%
4	570	2.9%
5	361	1.8%
6	226	1.1%
7	166	0.8%
8	168	0.8%
9	103	0.5%
10	70	0.4%

Value	Count	Frequency (%)
327	131	0.7%
232	89	0.4%
121	53	0.3%
103	36	0.2%
96	73	0.4%
91	34	0.2%
87	32	0.2%
65	27	0.1%
52	41	0.2%
50	16	0.1%

availability_365
Real number (ℝ)

Zeros

Distinct	366
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	112.9012

Minimum	0
Maximum	365
Zeros	7176
Zeros (%)	35.9%
Negative	0
Negative (%)	0.0%
Memory size	156.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	44
Q3	229
95-th percentile	359
Maximum	365
Range	365
Interquartile range (IQR)	229

Descriptive statistics

Standard deviation	131.76223
Coefficient of variation (CV)	1.1670578
Kurtosis	-1.0070922
Mean	112.9012
Median Absolute Deviation (MAD)	44
Skewness	0.75940929
Sum	2258024
Variance	17361.284
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7176	35.9%
365	510	2.5%
364	225	1.1%
1	181	0.9%
5	136	0.7%
89	124	0.6%
179	121	0.6%
2	119	0.6%
3	118	0.6%
6	110	0.5%
Other values (356)	11180	55.9%

Value	Count	Frequency (%)
0	7176	35.9%
1	181	0.9%
2	119	0.6%
3	118	0.6%
4	110	0.5%
5	136	0.7%
6	110	0.5%
7	98	0.5%
8	85	0.4%
9	85	0.4%

Value	Count	Frequency (%)
365	510	2.5%
364	225	1.1%
363	98	0.5%
362	69	0.3%
361	48	0.2%
360	34	0.2%
359	52	0.3%
358	62	0.3%
357	37	0.2%
356	28	0.1%

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365
0	9138664	Private Lg Room 15 min to Manhattan	47594947	Iris	Queens	Sunnyside	40.74271	-73.92493	Private room	74	2	6	2019-05-26	0.13	1	5
1	31444015	TIME SQUARE CHARMING ONE BED IN HELL'S KITCHEN,NYC	8523790	Johlex	Manhattan	Hell's Kitchen	40.76682	-73.98878	Entire home/apt	170	3	0	NaN	NaN	1	188
2	8741020	Voted #1 Location Quintessential 1BR W Village Apt	45854238	John	Manhattan	West Village	40.73631	-74.00611	Entire home/apt	245	3	51	2018-09-19	1.12	1	0
3	34602077	Spacious 1 bedroom apartment 15min from Manhattan	261055465	Regan	Queens	Astoria	40.76424	-73.92351	Entire home/apt	125	3	1	2019-05-24	0.65	1	13
4	23203149	Big beautiful bedroom in huge Bushwick apartment	143460	Megan	Brooklyn	Bushwick	40.69839	-73.92044	Private room	65	2	8	2019-06-23	0.52	2	8
5	4402805	LRG 2br BKLYN APT CLOSE TO TRAINS AND PARK	22807362	Jenny	Brooklyn	Prospect-Lefferts Gardens	40.66025	-73.96270	Entire home/apt	120	3	3	2018-08-28	0.05	1	16
6	30070126	✩Prime Renovated 1/1 Apartment in Upper East Side✩	4968673	Sean	Manhattan	Upper East Side	40.76831	-73.95929	Entire home/apt	200	5	2	2019-05-26	0.68	1	71
7	34231172	Fully renovated brick house floor in Brooklyn	59642348	Kevin	Brooklyn	Sunset Park	40.64550	-74.01262	Entire home/apt	95	1	9	2019-07-08	9.00	1	106
8	5856760	Renovated 1BR in exciting, convenient area	29408349	Chad	Manhattan	Chinatown	40.71490	-73.99976	Entire home/apt	179	5	7	2017-04-18	0.14	1	0
9	7929441	Beautiful Loft w/ Waterfront View!	1453898	Anthony	Brooklyn	Williamsburg	40.71268	-73.96676	Private room	105	2	232	2019-06-19	5.00	3	64

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365
19990	5192459	Quiet Room in 4BR UWS Brownstone	10677483	Greg	Manhattan	Upper West Side	40.80173	-73.96625	Private room	70	1	0	NaN	NaN	1	0
19991	1327940	Huge Gorgeous Park View Apartment!	3290436	Hadar	Brooklyn	Flatbush	40.65335	-73.96257	Entire home/apt	120	3	13	2016-08-27	0.28	2	327
19992	23612681	Shared Room 1 Stop from Manhattan on the F Train	55724558	Taylor	Queens	Long Island City	40.76006	-73.94080	Private room	55	4	2	2019-06-01	0.65	5	89
19993	34485745	Midtown Manhattan Stunner - Private room	261632622	Royalton	Manhattan	Theater District	40.75491	-73.98507	Private room	100	1	3	2019-06-16	3.00	9	318
19994	25616250	Stylish, spacious, private 1BR apt in Ditmas Park	125396920	Adam	Brooklyn	Flatbush	40.64314	-73.95705	Entire home/apt	75	3	10	2019-01-03	0.84	1	0
19995	7094539	Tranquil haven in bubbly Brooklyn	2052211	Adriana	Brooklyn	Windsor Terrace	40.65360	-73.97546	Entire home/apt	143	14	2	2016-08-27	0.04	1	10
19996	4424261	Large 1 BR with backyard on UWS	3447311	Sarah	Manhattan	Upper West Side	40.80188	-73.96808	Entire home/apt	200	2	22	2019-05-21	0.50	1	0
19997	4545882	Amazing studio/Loft with a backyard	23569951	Kaveh	Manhattan	Upper East Side	40.78110	-73.94567	Entire home/apt	220	3	28	2019-05-23	0.50	1	293
19998	26518547	U2 comfortable double bed sleeps 2 guests	295128	Carol Gloria	Bronx	Clason Point	40.81225	-73.85502	Private room	80	1	4	2019-07-01	1.48	7	365
19999	33631782	Private Bedroom in Williamsburg Apt!	8569221	Andi	Brooklyn	Williamsburg	40.71829	-73.95819	Private room	109	3	3	2019-04-28	1.07	2	97

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Missing values

Sample